
package com.grq.mis.dao;

import com.grq.mis.entity.Order;
import org.beetl.sql.mapper.BaseMapper;
import org.beetl.sql.mapper.annotation.Sql;
import org.beetl.sql.mapper.annotation.SqlResource;
import org.springframework.stereotype.Repository;

@SqlResource("order")
@Repository
public interface OrderDao extends BaseMapper<Order> {

    @Sql("select sum(pay_money) from t_order")
    long allMoney();

    @Sql("select sum(pay_money) from t_order where DATE_FORMAT(create_time, '%Y-%m-%d') = ?")
    long todayMoney(String today);
}
